Overview

Brought to you by YData

Dataset statistics

Number of variables	15
Number of observations	5121
Missing cells	12098
Missing cells (%)	15.7%
Total size in memory	600.2 KiB
Average record size in memory	120.0 B

Variable types

Text	14
Numeric	1

Alerts

`datacommons_id` has 1792 (35.0%) missing values	Missing
`locality_code` has 5109 (99.8%) missing values	Missing
`locality_name` has 5109 (99.8%) missing values	Missing
`aggregation_level` is highly skewed (γ1 = 20.59127781)	Skewed
`location_key` has unique values	Unique

Reproduction

Analysis started	2025-02-23 15:00:51.414308
Analysis finished	2025-02-23 15:00:52.042035
Duration	0.63 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

location_key
Text

Unique

Distinct	5121
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	13
Median length	11
Mean length	10.94317516
Min length	8

Characters and Unicode

Total characters	56040
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5121 ?
Unique (%)	100.0%

Sample

1st row	DE_BB_12051
2nd row	DE_BB_12052
3rd row	DE_BB_12053
4th row	DE_BB_12054
5th row	DE_BB_12060

Value	Count	Frequency (%)
de_bb_12064	1	< 0.1%
us_wv_54093	1	< 0.1%
us_wv_54095	1	< 0.1%
us_wv_54097	1	< 0.1%
us_wv_54099	1	< 0.1%
us_wv_54101	1	< 0.1%
us_wv_54103	1	< 0.1%
us_wv_54105	1	< 0.1%
us_wv_54107	1	< 0.1%
us_wv_54109	1	< 0.1%
Other values (5111)	5111	99.8%

Most occurring characters

Value	Count	Frequency (%)
_	10242	18.3%
S	4969	8.9%
0	4832	8.6%
1	4529	8.1%
U	3263	5.8%
2	2821	5.0%
3	2605	4.6%
5	2302	4.1%
7	2052	3.7%
E	1953	3.5%
Other values (27)	16472	29.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	56040	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
_	10242	18.3%
S	4969	8.9%
0	4832	8.6%
1	4529	8.1%
U	3263	5.8%
2	2821	5.0%
3	2605	4.6%
5	2302	4.1%
7	2052	3.7%
E	1953	3.5%
Other values (27)	16472	29.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	56040	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
_	10242	18.3%
S	4969	8.9%
0	4832	8.6%
1	4529	8.1%
U	3263	5.8%
2	2821	5.0%
3	2605	4.6%
5	2302	4.1%
7	2052	3.7%
E	1953	3.5%
Other values (27)	16472	29.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	56040	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
_	10242	18.3%
S	4969	8.9%
0	4832	8.6%
1	4529	8.1%
U	3263	5.8%
2	2821	5.0%
3	2605	4.6%
5	2302	4.1%
7	2052	3.7%
E	1953	3.5%
Other values (27)	16472	29.4%

place_id
Text

Distinct	5079
Distinct (%)	> 99.9%
Missing	41
Missing (%)	0.8%
Memory size	40.1 KiB

Length

Max length	27
Median length	27
Mean length	27
Min length	27

Characters and Unicode

Total characters	137160
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5078 ?
Unique (%)	> 99.9%

Sample

1st row	ChIJN8I30-XAqEcRhUxEEOyL_kg
2nd row	ChIJX0qVWUJ0CEcROq1_4LUv1FA
3rd row	ChIJb_u1AiqYB0cRwDteW0YgIQQ
4th row	ChIJt9Y6hM31qEcRm-yqC5j4ZcU
5th row	ChIJuRSkBF66qUcRCDglm8hflWE

Value	Count	Frequency (%)
chij5tcocraypbircmzhtz37seq	2	< 0.1%
chij3styuhaacecrirhunlsslgc	1	< 0.1%
chijtuu0ylenb0cr3_w_qw_ineq	1	< 0.1%
chijy4xdqce3qucrkt7cnqbuloa	1	< 0.1%
chijwriqvfwrqecrm8p0zhtxuys	1	< 0.1%
chiju1436wdrrkcrusbulcg_aga	1	< 0.1%
chij4bz4zl12cecrafdesxrch78	1	< 0.1%
chij2qr06xbwqecrmh5rrzoh8vy	1	< 0.1%
chijjyvqja6jqucr9bc4ax_iag8	1	< 0.1%
chijauk8it1rqecrwktfw0ygiqu	1	< 0.1%
Other values (5069)	5069	99.8%

Most occurring characters

Value	Count	Frequency (%)
I	8734	6.4%
R	6860	5.0%
h	6779	4.9%
C	6482	4.7%
J	6427	4.7%
c	3085	2.2%
Y	2937	2.1%
g	2900	2.1%
4	2588	1.9%
Q	2588	1.9%
Other values (54)	87780	64.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	137160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	8734	6.4%
R	6860	5.0%
h	6779	4.9%
C	6482	4.7%
J	6427	4.7%
c	3085	2.2%
Y	2937	2.1%
g	2900	2.1%
4	2588	1.9%
Q	2588	1.9%
Other values (54)	87780	64.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	137160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	8734	6.4%
R	6860	5.0%
h	6779	4.9%
C	6482	4.7%
J	6427	4.7%
c	3085	2.2%
Y	2937	2.1%
g	2900	2.1%
4	2588	1.9%
Q	2588	1.9%
Other values (54)	87780	64.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	137160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	8734	6.4%
R	6860	5.0%
h	6779	4.9%
C	6482	4.7%
J	6427	4.7%
c	3085	2.2%
Y	2937	2.1%
g	2900	2.1%
4	2588	1.9%
Q	2588	1.9%
Other values (54)	87780	64.0%

wikidata_id
Text

Distinct	5097
Distinct (%)	> 99.9%
Missing	23
Missing (%)	0.4%
Memory size	40.1 KiB

Length

Max length	9
Median length	7
Mean length	6.766378972
Min length	3

Characters and Unicode

Total characters	34495
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5096 ?
Unique (%)	> 99.9%

Sample

1st row	Q3931
2nd row	Q3214
3rd row	Q4024
4th row	Q1711
5th row	Q6115

Value	Count	Frequency (%)
q1492	2	< 0.1%
q6109	1	< 0.1%
q115413	1	< 0.1%
q4024	1	< 0.1%
q8520	1	< 0.1%
q6115	1	< 0.1%
q6173	1	< 0.1%
q6165	1	< 0.1%
q6139	1	< 0.1%
q3931	1	< 0.1%
Other values (5087)	5087	99.8%

Most occurring characters

Value	Count	Frequency (%)
Q	5098	14.8%
1	4325	12.5%
4	3637	10.5%
5	3184	9.2%
9	2863	8.3%
8	2775	8.0%
6	2745	8.0%
0	2691	7.8%
2	2495	7.2%
3	2371	6.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34495	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	5098	14.8%
1	4325	12.5%
4	3637	10.5%
5	3184	9.2%
9	2863	8.3%
8	2775	8.0%
6	2745	8.0%
0	2691	7.8%
2	2495	7.2%
3	2371	6.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34495	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	5098	14.8%
1	4325	12.5%
4	3637	10.5%
5	3184	9.2%
9	2863	8.3%
8	2775	8.0%
6	2745	8.0%
0	2691	7.8%
2	2495	7.2%
3	2371	6.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34495	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	5098	14.8%
1	4325	12.5%
4	3637	10.5%
5	3184	9.2%
9	2863	8.3%
8	2775	8.0%
6	2745	8.0%
0	2691	7.8%
2	2495	7.2%
3	2371	6.9%

datacommons_id
Text

Missing

Distinct	3329
Distinct (%)	100.0%
Missing	1792
Missing (%)	35.0%
Memory size	40.1 KiB

Length

Max length	13
Median length	11
Mean length	10.93872034
Min length	9

Characters and Unicode

Total characters	36415
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3329 ?
Unique (%)	100.0%

Sample

1st row	iso/IT-AL
2nd row	iso/IT-AT
3rd row	iso/IT-BI
4th row	iso/IT-CN
5th row	iso/IT-NO

Value	Count	Frequency (%)
iso/it-al	1	< 0.1%
geoid/56031	1	< 0.1%
geoid/56033	1	< 0.1%
geoid/56035	1	< 0.1%
geoid/56037	1	< 0.1%
geoid/56039	1	< 0.1%
geoid/56041	1	< 0.1%
geoid/56043	1	< 0.1%
geoid/56045	1	< 0.1%
geoid/56015	1	< 0.1%
Other values (3319)	3319	99.7%

Most occurring characters

Value	Count	Frequency (%)
I	3336	9.2%
o	3329	9.1%
/	3329	9.1%
e	3226	8.9%
g	3226	8.9%
d	3226	8.9%
1	3049	8.4%
0	3044	8.4%
3	1802	4.9%
2	1572	4.3%
Other values (30)	7276	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	36415	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	3336	9.2%
o	3329	9.1%
/	3329	9.1%
e	3226	8.9%
g	3226	8.9%
d	3226	8.9%
1	3049	8.4%
0	3044	8.4%
3	1802	4.9%
2	1572	4.3%
Other values (30)	7276	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	36415	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	3336	9.2%
o	3329	9.1%
/	3329	9.1%
e	3226	8.9%
g	3226	8.9%
d	3226	8.9%
1	3049	8.4%
0	3044	8.4%
3	1802	4.9%
2	1572	4.3%
Other values (30)	7276	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	36415	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	3336	9.2%
o	3329	9.1%
/	3329	9.1%
e	3226	8.9%
g	3226	8.9%
d	3226	8.9%
1	3049	8.4%
0	3044	8.4%
3	1802	4.9%
2	1572	4.3%
Other values (30)	7276	20.0%

country_code
Text

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10242
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DE
2nd row	DE
3rd row	DE
4th row	DE
5th row	DE

Value	Count	Frequency (%)
us	3228	63.0%
es	1378	26.9%
de	412	8.0%
it	103	2.0%

Most occurring characters

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

country_name
Text

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	24
Median length	24
Mean length	17.13747315
Min length	5

Characters and Unicode

Total characters	87761
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Germany
2nd row	Germany
3rd row	Germany
4th row	Germany
5th row	Germany

Value	Count	Frequency (%)
united	3228	21.8%
states	3228	21.8%
of	3228	21.8%
america	3228	21.8%
spain	1378	9.3%
germany	412	2.8%
italy	103	0.7%

Most occurring characters

Value	Count	Frequency (%)
e	10096	11.5%
t	9787	11.2%
	9684	11.0%
a	8349	9.5%
i	7834	8.9%
n	5018	5.7%
S	4606	5.2%
r	3640	4.1%
m	3640	4.1%
U	3228	3.7%
Other values (11)	21879	24.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87761	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10096	11.5%
t	9787	11.2%
	9684	11.0%
a	8349	9.5%
i	7834	8.9%
n	5018	5.7%
S	4606	5.2%
r	3640	4.1%
m	3640	4.1%
U	3228	3.7%
Other values (11)	21879	24.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87761	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10096	11.5%
t	9787	11.2%
	9684	11.0%
a	8349	9.5%
i	7834	8.9%
n	5018	5.7%
S	4606	5.2%
r	3640	4.1%
m	3640	4.1%
U	3228	3.7%
Other values (11)	21879	24.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87761	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10096	11.5%
t	9787	11.2%
	9684	11.0%
a	8349	9.5%
i	7834	8.9%
n	5018	5.7%
S	4606	5.2%
r	3640	4.1%
m	3640	4.1%
U	3228	3.7%
Other values (11)	21879	24.9%

subregion1_code
Text

Distinct	89
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10242
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Value	Count	Frequency (%)
ct	1091	21.3%
tx	254	5.0%
md	224	4.4%
ga	160	3.1%
va	133	2.6%
ky	120	2.3%
mo	115	2.2%
ks	105	2.1%
il	102	2.0%
nc	100	2.0%
Other values (79)	2717	53.1%

Most occurring characters

Value	Count	Frequency (%)
T	1576	15.4%
C	1456	14.2%
N	870	8.5%
A	821	8.0%
M	720	7.0%
I	550	5.4%
D	391	3.8%
O	380	3.7%
S	347	3.4%
K	331	3.2%
Other values (23)	2800	27.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	1576	15.4%
C	1456	14.2%
N	870	8.5%
A	821	8.0%
M	720	7.0%
I	550	5.4%
D	391	3.8%
O	380	3.7%
S	347	3.4%
K	331	3.2%
Other values (23)	2800	27.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	1576	15.4%
C	1456	14.2%
N	870	8.5%
A	821	8.0%
M	720	7.0%
I	550	5.4%
D	391	3.8%
O	380	3.7%
S	347	3.4%
K	331	3.2%
Other values (23)	2800	27.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	1576	15.4%
C	1456	14.2%
N	870	8.5%
A	821	8.0%
M	720	7.0%
I	550	5.4%
D	391	3.8%
O	380	3.7%
S	347	3.4%
K	331	3.2%
Other values (23)	2800	27.3%

subregion1_name
Text

Distinct	91
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	24
Median length	22
Mean length	9.024409295
Min length	4

Characters and Unicode

Total characters	46214
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Brandenburg
2nd row	Brandenburg
3rd row	Brandenburg
4th row	Brandenburg
5th row	Brandenburg

Value	Count	Frequency (%)
cataluña	1083	17.3%
texas	254	4.1%
north	206	3.3%
de	200	3.2%
madrid	200	3.2%
comunidad	200	3.2%
virginia	188	3.0%
georgia	160	2.6%
carolina	146	2.3%
new	127	2.0%
Other values (93)	3497	55.9%

Most occurring characters

Value	Count	Frequency (%)
a	8342	18.1%
i	3799	8.2%
n	2929	6.3%
o	2656	5.7%
s	2579	5.6%
e	2356	5.1%
t	2305	5.0%
l	2232	4.8%
r	2116	4.6%
u	1877	4.1%
Other values (41)	15023	32.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	46214	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	8342	18.1%
i	3799	8.2%
n	2929	6.3%
o	2656	5.7%
s	2579	5.6%
e	2356	5.1%
t	2305	5.0%
l	2232	4.8%
r	2116	4.6%
u	1877	4.1%
Other values (41)	15023	32.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	46214	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	8342	18.1%
i	3799	8.2%
n	2929	6.3%
o	2656	5.7%
s	2579	5.6%
e	2356	5.1%
t	2305	5.0%
l	2232	4.8%
r	2116	4.6%
u	1877	4.1%
Other values (41)	15023	32.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	46214	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	8342	18.1%
i	3799	8.2%
n	2929	6.3%
o	2656	5.7%
s	2579	5.6%
e	2356	5.1%
t	2305	5.0%
l	2232	4.8%
r	2116	4.6%
u	1877	4.1%
Other values (41)	15023	32.5%

subregion2_code
Text

Distinct	4680
Distinct (%)	91.6%
Missing	12
Missing (%)	0.2%
Memory size	40.1 KiB

Length

Max length	7
Median length	5
Mean length	4.947739284
Min length	2

Characters and Unicode

Total characters	25278
Distinct characters	32
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4266 ?
Unique (%)	83.5%

Sample

1st row	12051
2nd row	12052
3rd row	12053
4th row	12054
5th row	12060

Value	Count	Frequency (%)
08115	3	0.1%
12073	3	0.1%
08125	3	0.1%
08117	3	0.1%
12053	3	0.1%
12061	3	0.1%
12051	3	0.1%
08111	3	0.1%
12065	3	0.1%
08119	3	0.1%
Other values (4670)	5079	99.4%

Most occurring characters

Value	Count	Frequency (%)
0	4832	19.1%
1	4521	17.9%
2	2769	11.0%
3	2594	10.3%
5	2252	8.9%
7	2026	8.0%
4	1747	6.9%
8	1691	6.7%
9	1582	6.3%
6	1058	4.2%
Other values (22)	206	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25278	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4832	19.1%
1	4521	17.9%
2	2769	11.0%
3	2594	10.3%
5	2252	8.9%
7	2026	8.0%
4	1747	6.9%
8	1691	6.7%
9	1582	6.3%
6	1058	4.2%
Other values (22)	206	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25278	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4832	19.1%
1	4521	17.9%
2	2769	11.0%
3	2594	10.3%
5	2252	8.9%
7	2026	8.0%
4	1747	6.9%
8	1691	6.7%
9	1582	6.3%
6	1058	4.2%
Other values (22)	206	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25278	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4832	19.1%
1	4521	17.9%
2	2769	11.0%
3	2594	10.3%
5	2252	8.9%
7	2026	8.0%
4	1747	6.9%
8	1691	6.7%
9	1582	6.3%
6	1058	4.2%
Other values (22)	206	0.8%

subregion2_name
Text

Distinct	3834
Distinct (%)	75.0%
Missing	12
Missing (%)	0.2%
Memory size	40.1 KiB

Length

Max length	44
Median length	33
Mean length	13.22528871
Min length	3

Characters and Unicode

Total characters	67568
Distinct characters	81
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3401 ?
Unique (%)	66.6%

Sample

1st row	Brandenburg an der Havel
2nd row	Cottbus
3rd row	Frankfurt an der Oder
4th row	Potsdam
5th row	Barnim

Value	Count	Frequency (%)
county	3008	30.1%
de	334	3.3%
la	140	1.4%
sant	92	0.9%
municipio	78	0.8%
del	77	0.8%
parish	64	0.6%
el	50	0.5%
santa	42	0.4%
san	40	0.4%
Other values (3934)	6078	60.8%

Most occurring characters

Value	Count	Frequency (%)
n	6219	9.2%
o	5846	8.7%
a	5025	7.4%
	4894	7.2%
t	4838	7.2%
e	4496	6.7%
u	4228	6.3%
C	3691	5.5%
y	3444	5.1%
r	3194	4.7%
Other values (71)	21693	32.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67568	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	6219	9.2%
o	5846	8.7%
a	5025	7.4%
	4894	7.2%
t	4838	7.2%
e	4496	6.7%
u	4228	6.3%
C	3691	5.5%
y	3444	5.1%
r	3194	4.7%
Other values (71)	21693	32.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67568	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	6219	9.2%
o	5846	8.7%
a	5025	7.4%
	4894	7.2%
t	4838	7.2%
e	4496	6.7%
u	4228	6.3%
C	3691	5.5%
y	3444	5.1%
r	3194	4.7%
Other values (71)	21693	32.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67568	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	6219	9.2%
o	5846	8.7%
a	5025	7.4%
	4894	7.2%
t	4838	7.2%
e	4496	6.7%
u	4228	6.3%
C	3691	5.5%
y	3444	5.1%
r	3194	4.7%
Other values (71)	21693	32.1%

locality_code
Text

Missing

Distinct	12
Distinct (%)	100.0%
Missing	5109
Missing (%)	99.8%
Memory size	40.1 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	36
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	100.0%

Sample

1st row	ACE
2nd row	FUE
3rd row	GMZ
4th row	LPA
5th row	SPC

Value	Count	Frequency (%)
ace	1	8.3%
fue	1	8.3%
gmz	1	8.3%
lpa	1	8.3%
spc	1	8.3%
tfn	1	8.3%
vde	1	8.3%
bcn	1	8.3%
mad	1	8.3%
sfo	1	8.3%
Other values (2)	2	16.7%

Most occurring characters

Value	Count	Frequency (%)
A	4	11.1%
C	4	11.1%
E	3	8.3%
F	3	8.3%
N	3	8.3%
L	2	5.6%
P	2	5.6%
T	2	5.6%
S	2	5.6%
M	2	5.6%
Other values (8)	9	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	36	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	4	11.1%
C	4	11.1%
E	3	8.3%
F	3	8.3%
N	3	8.3%
L	2	5.6%
P	2	5.6%
T	2	5.6%
S	2	5.6%
M	2	5.6%
Other values (8)	9	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	36	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	4	11.1%
C	4	11.1%
E	3	8.3%
F	3	8.3%
N	3	8.3%
L	2	5.6%
P	2	5.6%
T	2	5.6%
S	2	5.6%
M	2	5.6%
Other values (8)	9	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	36	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	4	11.1%
C	4	11.1%
E	3	8.3%
F	3	8.3%
N	3	8.3%
L	2	5.6%
P	2	5.6%
T	2	5.6%
S	2	5.6%
M	2	5.6%
Other values (8)	9	25.0%

locality_name
Text

Missing

Distinct	12
Distinct (%)	100.0%
Missing	5109
Missing (%)	99.8%
Memory size	40.1 KiB

Length

Max length	13
Median length	12
Mean length	9.666666667
Min length	6

Characters and Unicode

Total characters	116
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	100.0%

Sample

1st row	Lanzarote
2nd row	Fuerteventura
3rd row	La Gomera
4th row	Gran Canaria
5th row	La Palma

Value	Count	Frequency (%)
la	2	10.5%
lanzarote	1	5.3%
fuerteventura	1	5.3%
gomera	1	5.3%
gran	1	5.3%
canaria	1	5.3%
palma	1	5.3%
tenerife	1	5.3%
el	1	5.3%
hierro	1	5.3%
Other values (8)	8	42.1%

Most occurring characters

Value	Count	Frequency (%)
a	19	16.4%
r	13	11.2%
e	11	9.5%
n	9	7.8%
	7	6.0%
t	6	5.2%
i	6	5.2%
o	6	5.2%
l	4	3.4%
L	3	2.6%
Other values (24)	32	27.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	116	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	19	16.4%
r	13	11.2%
e	11	9.5%
n	9	7.8%
	7	6.0%
t	6	5.2%
i	6	5.2%
o	6	5.2%
l	4	3.4%
L	3	2.6%
Other values (24)	32	27.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	116	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	19	16.4%
r	13	11.2%
e	11	9.5%
n	9	7.8%
	7	6.0%
t	6	5.2%
i	6	5.2%
o	6	5.2%
l	4	3.4%
L	3	2.6%
Other values (24)	32	27.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	116	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	19	16.4%
r	13	11.2%
e	11	9.5%
n	9	7.8%
	7	6.0%
t	6	5.2%
i	6	5.2%
o	6	5.2%
l	4	3.4%
L	3	2.6%
Other values (24)	32	27.6%

iso_3166_1_alpha_2
Text

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10242
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DE
2nd row	DE
3rd row	DE
4th row	DE
5th row	DE

Value	Count	Frequency (%)
us	3228	63.0%
es	1378	26.9%
de	412	8.0%
it	103	2.0%

Most occurring characters

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10242	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	4606	45.0%
U	3228	31.5%
E	1790	17.5%
D	412	4.0%
I	103	1.0%
T	103	1.0%

iso_3166_1_alpha_3
Text

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	40.1 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	15363
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DEU
2nd row	DEU
3rd row	DEU
4th row	DEU
5th row	DEU

Value	Count	Frequency (%)
usa	3228	63.0%
esp	1378	26.9%
deu	412	8.0%
ita	103	2.0%

Most occurring characters

Value	Count	Frequency (%)
S	4606	30.0%
U	3640	23.7%
A	3331	21.7%
E	1790	11.7%
P	1378	9.0%
D	412	2.7%
I	103	0.7%
T	103	0.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15363	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	4606	30.0%
U	3640	23.7%
A	3331	21.7%
E	1790	11.7%
P	1378	9.0%
D	412	2.7%
I	103	0.7%
T	103	0.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15363	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	4606	30.0%
U	3640	23.7%
A	3331	21.7%
E	1790	11.7%
P	1378	9.0%
D	412	2.7%
I	103	0.7%
T	103	0.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15363	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	4606	30.0%
U	3640	23.7%
A	3331	21.7%
E	1790	11.7%
P	1378	9.0%
D	412	2.7%
I	103	0.7%
T	103	0.7%

aggregation_level
Real number (ℝ)

Skewed

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.002343292

Minimum	2
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	40.1 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	3
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.04835553648
Coefficient of variation (CV)	0.0241494736
Kurtosis	422.1655981
Mean	2.002343292
Median Absolute Deviation (MAD)	0
Skewness	20.59127781
Sum	10254
Variance	0.002338257909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
2	5109	99.8%
3	12	0.2%

Value	Count	Frequency (%)
2	5109	99.8%
3	12	0.2%

Value	Count	Frequency (%)
3	12	0.2%
2	5109	99.8%

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks